約 3,764,303 件
https://w.atwiki.jp/notos_marseille/pages/15.html
@wikiへようこそ ウィキはみんなで気軽にホームページ編集できるツールです。 このページは自由に編集することができます。 メールで送られてきたパスワードを用いてログインすることで、各種変更（サイト名、トップページ、メンバー管理、サイドページ、デザイン、ページ管理、等）することができます まずはこちらをご覧ください。 @wikiの基本操作 用途別のオススメ機能紹介 @wikiの設定/管理 分からないことは？ @wiki ご利用ガイド よくある質問 無料で会員登録できるSNS内の@wiki助け合いコミュニティ @wiki更新情報 @wikiへのお問合せフォーム 等をご活用ください @wiki助け合いコミュニティの掲示板スレッド一覧 #atfb_bbs_list その他お勧めサービスについて 大容量１Ｇ、PHP/CGI、MySQL、FTPが使える無料ホームページは@PAGES 無料ブログ作成は@WORDをご利用ください 2ch型の無料掲示板は@chsをご利用ください フォーラム型の無料掲示板は@bbをご利用ください お絵かき掲示板は@paintをご利用ください その他の無料掲示板は@bbsをご利用ください 無料ソーシャルプロフィールサービス @flabo(アットフラボ) おすすめ機能 気になるニュースをチェック 関連するブログ一覧を表示 その他にもいろいろな機能満載！！ @wikiプラグイン @wiki便利ツール @wiki構文 @wikiプラグイン一覧 まとめサイト作成支援ツール バグ・不具合を見つけたら？ 要望がある場合は？ お手数ですが、メールでお問い合わせください。
https://w.atwiki.jp/onechord/pages/11.html
Fedora 7 バックアップから もうひとつのディスクのマウント。 /etc/fstab追加 /dev/sda1 /mnt/hdb1 ext3 defaults 0 0 なぜかデバイス名がsdaになっていた。 mydnsへの登録のcron追加 /etc/cron.hourlyにmydns.shを戻す。 ntsysvで以下のサービス立ち上げ httpd mysqld named /var/www/html以下バックアップから戻す。mvで。 /var/local 戻す mysql設定 /etc/my.cnf 戻す /var/lib/mysql 戻す mysql リスタート php pearが入ってなかったの # yum install php-pear # yum install php-pear-MDB2-Driver-mysql httpd認証 /etc/httpd/conf.d/auth_mysql.confに以下追加 # 2007/06/12 by yuzawa Location /diary AuthName "MySQL authenticated zone" AuthType Basic AuthMYSQLEnable on AuthMySQLUser authuser AuthMySQLPassword PaSsW0Rd AuthMySQLDB auth AuthMySQLUserTable users AuthMySQLNameField user_name AuthMySQLPasswordField user_passwd require valid-user /Location httpd MovableType /var/www/cgi-bin/mymt 戻す kubomata log /etc/cron.daily/myget.shコピー get_tmp.shで調整 p/rep2のため # yum install php-mbstring 残作業。 ついでにphpMyAdminアップデート http //www.phpmyadmin.net/home_page/downloads.phpからget /var/www/html以下で解凍 mail cacti # yum install cacti # yum install net-snmp-utils /etc/httpd/conf.d/cacti.confのアクセス制限なしに
https://w.atwiki.jp/mrfrtech/pages/74.html
Market Scenario The introduction of technologies such as supervisory control and data acquisition (SCADA) and smart grid network management has modernized the current power grid infrastructure to make performance, adaptability, and reliability more sophisticated. The smart grid sensor is expected to show significant growth over the forecast period, in the lines of these factors. In addition, the increasing number of electrical thefts in commercial and residential areas, and the system of energy faults, and extreme weather conditions operational capacity is expected to drive the market over the forecast period. Novel coronavirus has Smart Grid Security Market Growth to open new avenues for those firms that are on the lookout for solutions that are reliable, efficiently managed, scalable, and are subscription-based, to remain more focused on the core business. The Smart Grid Security Market is bearing lesser impact of the COVID-19 outbreak compared to most other segments of the tech world. The conventional power grid system is being modernized into a smart grid to address issues such as power dissipation, concentrated information flow and growing safety and consistency concerns. On the other hand, security concerns and increased counterfeiting of energy utilities are presumed to hinder the growth of the market for smart grid sensors over the review period. In addition, the high energy consumption of smart grids is presumed to impede market growth over the projected period. In addition, the growing COVID 19 pandemics worldwide has created a major market disruption and is expected to continue its impact on the market in the foreseeable future. Request a Free Sample @ https //www.marketresearchfuture.com/sample_request/7168 Competitive Outlook Some of the key players of smart grid sensors market include ABB Ltd. (Switzerland), General Electric Company (U.S.), Oracle Corporation (U.S.), Siemens AG (Germany), Cisco Systems, Inc. (U.S.), Itron, Inc. (U.S.), Landis+Gyr (Switzerland), Schneider Electric SA (France), Tech Mahindra Ltd. (India), S C Electric Company (Illinois, U.S.), Aclara Technologies LLC (U.S.), Open Systems International, Inc. (Minnesota, U.S.), Esyasoft Technologies Pvt. Ltd. (India), Trilliant Holdings, Inc. (U.S.), Wipro Ltd. (India), NexGrid, LLC. (U.S.), Kamstrup A/S (Denmark), Globema (Poland), EnerNOC, Inc. (U.S), and e-Smart Systems Pvt. Ltd. (India). Segmentation The smart grid sensors is differentiated by component, sensors, solutions, service, and application. Based on sensors, the smart grid sensors market is sub-divided into dynamic line rating sensors, outage detection sensors, voltage/temperature sensors, transformer monitoring sensors, and others. The component segment consists of sensors, AMI meter, programmable logic controller (PLC), networking hardware, and others. Furthermore, the service is classified into deployment integration, consulting, support maintenance, and others. Smart grid sensors is further divided based on solutions that include smart grid distribution management, smart grid communication, substation automation, grid asset management, Advance Metering Infrastructure (AMI), and billing customer information system. Based on application segment, the smart grid sensors is segmented into Advanced Metering Infrastructure (AMI), smart energy meter, supervisory control and data acquisition (SCADA), and others Regional Analysis The smart grid sensors are geographically segmented into four different regions, namely North America, Asia Pacific , Europe and the rest of the world. North America is presumed the dominant region in the market for smart grid sensors. The United States and Canada are the region s leading nations. It is attributed to the region s rising suppliers of smart grid solutions to boost grid stability. In addition, Europe is expected to enjoy significant growth over the forecast period. Countries such as Germany, France and Great Britain are the region s leading countries. The Global Solar Inverter Market is geographically segmented as Europe , North America , Asia-Pacific and the rest of the world. Due to the increase in investments in the construction section, Asia-Pacific is likely to hold a majority of the market share over the forecast period. Demand for solar inverters in Asia-Pacific is expected to rise significantly due to growing demand for solar energy sources and increasing investment in the region s solar energy projects. Solar energy is seen as the best substitute for conventional energy sources for reducing carbon emissions by meeting the region s electricity needs. Table of Contents 1Executive Summary 2Scope of the Report 2.1Market Definition 2.2Scope of the Study 2.2.1Research objectives 2.2.2Assumptions Limitations 2.3Markets Structure Continued…. Browse Full Report Details @ https //www.marketresearchfuture.com/reports/smart-grid-security-market-7168 List of Tables Table 1 Global Smart Grid Security Market, By Region, 2020-2027 Table 2 North America Smart Grid Security Market, By Country, 2020-2027 Table 3 Europe Smart Grid Security Market, By Country, 2020-2027 Continued… List of Figures FIGURE 1 Global Smart Grid Security Market Segmentation FIGURE 2 Forecast Methodology FIGURE 3 Porter’s Five Forces Analysis Of Global Smart Grid Security Market Continued… B2B Telecommunication Market Information by Solution (Unified Communication and Collaboration), Deployment (Fixed, Mobile), Organization Size (Large, Enterprise), Application (Industrial, Commercial) and regions Trending #MRFR Report** https //ictmrfr.blogspot.com/2022/04/geofencing-market-companies-growth-with.html https //blogfreely.net/pranali004/telecom-expense-management-market-size-impressive-cagr-changing-business-scope https //postheaven.net/pranali004/financial-app-industry-impressive-cagr-changing-business-needs-scope-of https //market-research-future.tribe.so/post/openstack-service-market-research-impressive-cagr-changing-scope-of-current--6263de46791566c10c79891e https //www.scutify.com/articles/2022-04-24-infrastructure-as-a-service-industry-cagr-changing-business-scope-of-current-and-future-industry- About Market Research Future Market Research Future (MRFR) has created a niche in the world of market research. It is counted among the top market research companies that offer well-researched and updated market research reports and insights to businesses of all sizes. What sets us apart is our super-responsive team that offers quality work keeping clients abridged of the prospective challenges and opportunities in various markets. Our team is adept in their space as well as patiently listens to every client. The best part is they know their work inside out and possess the expertise to guide the client in the right direction and achieve results on a tight deadline. We are a one-stop solution for all your data research needs. Our team does not believe in the “one size fits all” approach to creating a report that is detailed and concise. We handle 13 industry verticals including Healthcare, Chemicals and Materials, Information and Communications Technology, Semiconductor and Electronics, Energy and Power, Food, Beverages Nutrition, Automobile, Consumer and Retail, Aerospace and Defense, Industrial Automation and Equipment, Packaging Transport, Construction, and Agriculture. With our unique approach for every market report, we aim to reach the zenith in qualitative business intelligence and syndicated market research. Contact Market Research Future (Part of Wantstats Research and Media Private Limited) 99 Hudson Street, 5Th Floor New York, NY 10013 United States of America 1 628 258 0071 (US) 44 2035 002 764 (UK) Email sales@marketresearchfuture.com Website https //www.marketresearchfuture.com
https://w.atwiki.jp/takaidohigasi/pages/27.html
テスト。気がついたときに見るよ。 - 管理人 2012-06-06 00 05 46 時間がかかりそうなので和訳する順番を考えねば・・・。 - 管理人 2012-06-06 00 07 36
https://w.atwiki.jp/th0901/pages/32.html
パッケージの入手 http //sourceforge.net/projects/sysbench/files/ よりsysbench-0.4.10.tar.gzを入手 sysbechのインストール # tar xvfz sysbench-0.4.10.tar.gz # cd sysbench-0.4.10 # ./configure # make # make install RPMの準備 以下のRPMをインストールする # rpm -qaa | grep MySQL MySQL-client-advanced-gpl-5.1.43-1.rhel4.x86_64 MySQL-server-advanced-gpl-5.1.43-1.rhel4.x86_64 MySQL-devel-advanced-gpl-5.1.43-1.rhel4.x86_64 データベース作成 # mysql -uroot -ppassword -e"create database sbtest;" テーブル作成 # /usr/local/bin/sysbench --test=oltp --mysql-table-engine=innodb --oltp-table-size=1000000 --mysql-user=root --mysql-password=password prepare sysbench 0.4.10 multi-threaded system evaluation benchmark No DB drivers specified, using mysql Creating table sbtest ... Creating 1000000 records in table sbtest ... 負荷掛け # /usr/local/bin/sysbench --test=oltp --oltp-table-size=1000000 --num-threads=4 --max-requests=0 --max-time=180 --mysql-engine-trx=yes --oltp-test-mode=complex --mysql-user=root --mysql-password=password run sysbench 0.4.10 multi-threaded system evaluation benchmark No DB drivers specified, using mysql WARNING Preparing of "BEGIN" is unsupported, using emulation (last message repeated 3 times) Running the test with following options Number of threads 4 Doing OLTP test. Running mixed OLTP test Using Special distribution (12 iterations, 1 pct of values are returned in 75 pct cases) Using "BEGIN" for starting transactions Using auto_inc on the id column Threads started! Time limit exceeded, exiting... (last message repeated 3 times) Done. OLTP test statistics queries performed read 236936 write 84620 other 33848 total 355404 transactions 16924 (93.99 per sec.) deadlocks 0 (0.00 per sec.) read/write requests 321556 (1785.87 per sec.) other operations 33848 (187.99 per sec.) Test execution summary total time 180.0555s total number of events 16924 total time taken by event execution 719.9606 per-request statistics min 5.76ms avg 42.54ms max 456.40ms approx. 95 percentile 77.24ms Threads fairness events (avg/stddev) 4231.0000/9.03 execution time (avg/stddev) 179.9901/0.02 テーブル削除 # /usr/local/bin/sysbench --test=oltp --mysql-user=root --mysql-password=password cleanup sysbench 0.4.10 multi-threaded system evaluation benchmark No DB drivers specified, using mysql Dropping table sbtest ... Done. その他負荷掛け 特定SQLのみ負荷掛け（例：insertのみ） /usr/local/bin/sysbench --test=oltp --oltp-table-size=1000000 --num-threads=4 --max-requests=0 --max-time=180 --mysql-engine-trx=yes --oltp-test-mode=nontrx --oltp-nontrx-mode=insert --mysql-user=root --mysql-password=password run オプション --oltp-nontrx-mode= で{select, update_key, update_nokey, insert, delete}に5種類のSQLが対応可能 マニュアル http //sysbench.sourceforge.net/docs/#database_mode
https://w.atwiki.jp/mtgflavortext/pages/2180.html
"Martyrs are cheaper than mercenaries, and a far better investment." ――General Varchild アライアンス "The only true immortality is in dying for a cause." ――Halvor Arensson, Kjeldoran Priest アライアンス 【M TG Wiki】 名前
https://w.atwiki.jp/mrfrtech/pages/131.html
Market Analysis The global Smart Commute Market Growth is predicted to touch USD 104.22 billion and at a whopping 25.52% CAGR between 2020- 2027, states the recent Market Research Future (MRFR) analysis. Smart commute, simply put, is traveling from a particular place to another regularly through metro, bicycle pooling, bike pooling, vanpooling, and others. Traffic management, parking management, smart ticketing, mobile app, and others are different solutions. These services provide eco-friendly traveling experience to people and make an active alternative to transportation for enterprise employees that can pick from effective commute option, which along with reducing the congestion, also helps in lowering the transportation cost. Various factors are propelling the global smart commute app market share. According to the recent MRFR report, such factors include high demographic rates, growing urban population, the use of smart and connected technologies in transportation infrastructure, growing demand for transportation as a service, decline in ownership of vehicles with shared mobility. Additional factors adding market growth include several upcoming railway projects, growing urbanization and industrialization, demand for public transport and smart transportation solutions as well as related components, services, and software, advances in technology like the implementation of electronic payment systems, traveler information systems, and automatic vehicle location systems, and benefits such as an increase in traveler convenience, reduce traffic congestion, lower emission levels, and improve fuel economy. On the contrary, high component cost, concerns about security and management data storage, the slow growth rate of GDP, susceptibility to cyberattacks, and the on-going COVID-19 impact are factors that may impede the global smart commute application market growth over the forecast period. Get a Free Sample @ https //www.marketresearchfuture.com/sample_request/6975 Market Segmentation The MRFR report highlights an inclusive segmental analysis of the global smart commute market based on solution and type. Based on type, the global smart commute market is segmented into metro, bicycle pooling, bike pooling, vanpooling, carpooling, and others. Based on the solution, the global smart commute market is segmented into traffic management, parking management, smart ticketing, mobile app, and others. Regional Analysis Based on the region, the global smart commute market report covers the recent trends and growth opportunities across the Asia Pacific (APAC), North America, Europe, the Rest of the World (RoW). Of these, the APAC region is predicted to have the lions share over the forecast period. Strict government norms and regulations related to greenhouse gas emissions, adoption of car sharing services, and the upcoming availability of zero-emission car sharing services are adding to the global smart commute market growth in the region. The global smart commute market in Europe is predicted to have healthy growth over the forecast period. Improved socio-economic conditions in France, the UK, and Germany are adding to the global smart commute market growth in the region. The global smart commute market in North America is predicted to have sound growth over the forecast period. Favorable incentives introduced by the government for promoting carpooling services are adding to the global smart commute market growth in the region. The global smart commute market in the RoW is predicted to have steady growth over the forecast period. Key Players Leading contenders profiled in the global smart commute market report include Carma Technology Corporation (Europe), Turo (US), BlaBlaCar (France), CommuteSMART (US), Oakland Smart Commute (California), Central Indiana Regional Transportation Authority (CIRTA) (US), ZipGo Technologies Pvt. Ltd (India), Metrolinx (Canada), ANI Technologies Pvt. Ltd.(India), Uber Technologies Inc. (India), Quick Ride (India), ePoolers Technologies Pvt. Ltd. (India), and South Florida Commuter Services (US). Industry players have incorporated several strategies such as mergers, new product launches, strategic alliances, geographic expansions, extensive R D activities, new product development, and others to stay at the forefront. Brows Full Report @ https //www.marketresearchfuture.com/reports/smart-commute-market-6975 Table of Contents 1 Executive Summary 2 Scope of The Report 2.1 Market Definition 2.2 Scope of The Study 2.2.1 Research Objectives 2.2.2 Assumptions Limitations 2.3 Market Structure Continued… Similar Report** B2B Telecommunication Market Information by Solution (Unified Communication and Collaboration), Deployment (Fixed, Mobile), Organization Size (Large, Enterprise), Application (Industrial, Commercial) and regions Trending #MRFR Report** https //ictmrfr.blogspot.com/2022/04/geofencing-market-companies-growth-with.html https //blogfreely.net/pranali004/telecom-expense-management-market-size-impressive-cagr-changing-business-scope https //postheaven.net/pranali004/financial-app-industry-impressive-cagr-changing-business-needs-scope-of https //market-research-future.tribe.so/post/openstack-service-market-research-impressive-cagr-changing-scope-of-current--6263de46791566c10c79891e https //www.scutify.com/articles/2022-04-24-infrastructure-as-a-service-industry-cagr-changing-business-scope-of-current-and-future-industry- About Market Research Future At Market Research Future (MRFR), we enable our customers to unravel the complexity of various industries through our Cooked Research Report (CRR), Half-Cooked Research Reports (HCRR), Raw Research Reports (3R), Continuous-Feed Research (CFR), and Market Research Consulting Services. Contact Market Research Future (Part of Wantstats Research and Media Private Limited) 99 Hudson Street, 5Th Floor New York, NY 10013 United States of America 1 628 258 0071 (US) 44 2035 002 764 (UK) Email sales@marketresearchfuture.com Website https //www.marketresearchfuture.com
https://w.atwiki.jp/marketresearch/pages/35.html
Beverage Cans Market Analysis and Insights Quince Market Insights (QMI) has released a new research study titled "Beverage Cans Market” 2023-2032, provides an in-depth analysis of the market by highlighting information on several factors such as “Industry size, share, growth, segmentation, manufacturers and developments, key trends, market drivers, restraints, constraints, regulations, distribution methods, opportunities, strategies, potential road maps, threats and annual forecast until 2032" Click on Link and Get the PDF Sample Copy (Including FULL TOC, Graphs, and Tables) of this report@ https //www.quincemarketinsights.com/request-sample-69964?Offpagepranali_3April23 An Outline of The Competitive Landscape of The Market This section contains comprehensive data on a number of key Beverage Cans market competitors, as well as information on recent changes, market contributions, and effective marketing methods. The report also provides a dashboard summary of the historical and current performance of the top corporations. Beverage Cans Market Size is part of a competitive market. Beverage Cans have evolved into strategic platforms that provide businesses with a stable foundation and information backbone. As a document, the company included the like Crown Holdings Inc. (Philadelphia, US), Ardagh Group S.A, (Luxemburg), CPMC Holdings Limited (China), Toyo Seikan Group Holdings Ltd. (Tokyo, Japan), Can-One Berhad (Malaysia), Can-Pack S.A (Poland), Ball Corporation (Colorado, US), Envases Universales (Spain), Universal Can Corporation (Tokyo, Japan), Interpack Group Inc. (China), GZ Industries (Nigeria), Showa Denko K.K (Tokyo, Japan), Swan Industries (Thailand) Limited (Thailand), Nampak Bevcan Limited (South Africa), The Olayan Group (Saudi Arabia), and Techpack Solutions Pvt Limited (Seoul, South Korea). Key Take away Industry drivers, restraints, and opportunities covered in the study A neutral perspective on the market performance Recent industry trends and developments Competitive landscape strategies of key players Potential niche segments and regions exhibiting promising growth covered Historical, current, and projected market size, in terms of value In-depth analysis of the Beverage Cans Market Market Segments The chapters on Beverage Cans segmentation allow the readers to understand consumer needs. It allows the business to grow with precision and accuracy. Analysts have highlighted the elements that are expected to influence the segments in the coming years. The publication segments the market on the basis of technology, services, and products. It details the Beverage Cans revenue earned by each of these segments and their potential in the years to come. ✦ Segmentation ✦ By Material Type (Aluminium, Steel, and PET), Beverage Type (Alcoholic Beverages, Non-Alcoholic Beverages, and Water), Structure (2-Piece and 3-Piece) What are the key dynamic factors that are detailed in the report? Key Market Dynamics The Global Beverage Cans Market research report details the latest industry trends, growth patterns, and research methodologies. The factors that directly contribute to the growth of the market include the production strategies and methodologies, development platforms, and the product model itself, wherein a small change would result in further changes in the overall report. All of these factors are explained in detail in the research study. Market Outlook The report also sheds light on some of the major factors, including R D, new product launches, M A, agreements, partnerships, joint ventures, collaborations, and growth of the key industry participants, on a regional and global basis. Major Features The report provides a thorough analysis of some of the significant factors, which include cost, capacity, capacity utilization rate, production, revenue, production rate, consumption, import/export, supply/demand, gross, market share, CAGR, and gross margin. Besides, the report provides a comprehensive study of the key influencing factors and market inclinations, in addition to the relevant market segments and sub-segments. Analytical Tools The Global Beverage Cans Market report consists the precisely studied and evaluated information of the key players and their market scope using several analytical tools, including SWOT analysis, Porter’s five forces analysis, investment return analysis, and feasibility study. These tools have been used to efficiently study the growth of major industry participants. Potential Customers The report offers detailed insights to users, service providers, suppliers, manufacturers, stockholders, and individuals who are interested in evaluating and self-studying this market. A Synopsis of The Regional Landscape Of The Market This section of the report provides key insights regarding various regions and the key players operating in each region. Economic, social, environmental, technological, and political factors have been taken into consideration while assessing the growth of the particular region/country. The readers will also get their hands on the value and sales data of each region and country for the period 2023-2032. North America (United States, Canada and Mexico), Asia-Pacific (China, Japan, Korea, India, Southeast Asia and Australia), South America (Brazil, Argentina), Europe (Germany, France, United Kingdom, Russia and Italy), Middle East Africa (UAE, Egypt, Saudi Arabia, and South Africa) Report Scope This report aims to provide an extensive presentation of the global market with both qualitative and quantitative analysis, in order to help readers develop business/growth strategies, evaluate the competitive landscape, assess their position in the current market, and make well-informed decisions regarding Beverage Cans Market. The Data is accessible from 2023 to 2032, and the market size, forecasts, and estimates are given in terms of output/shipments (in units) and revenue (in USD millions/billion). This study segments the world market in extensive detail information on regional market sizes for items by type, application, and player are also provided. Market sizes were estimated while taking the effects of COVID-19 and the Russia-Ukraine War into consideration. The analysis includes profiles of the competitive environment, key players, and their specific market shares to provide a detailed understanding of the industry. Additionally, It contains a SWOT Analysis, a PESTEL Analysis, and a Porter’s FIVE Forces Analysis to assist you in understanding the Market, Competitive Landscape, and Factors That affect it, as well as forecasting the company’s future. Report Includes Following Questions What is the anticipated growth rate of the global Beverage Cans Market in the forecast period? Which regional segment is estimated to account for a massive share of the global Beverage Cans Market? What are the primary driving factors of the global Beverage Cans Market? What are the vital challenges faced by the prominent players in the global Beverage Cans Market? Which current trends are likely to offer promising growth prospects in the next few years? How is the competitive landscape of the global Beverage Cans Market at present? What are the key driving factors of the global Beverage Cans Market? Which latest trends are anticipated to offer potential growth prospected in the coming years? Make an Enquiry for purchasing this Beverage Cans Market Report @ https //www.quincemarketinsights.com/enquiry-before-buying/enquiry-before-buying-69964?Offpage/pranali_3April23 About Us QMI has the most comprehensive collection of market research products and services available on the web. We deliver reports from virtually all major publications and refresh our list regularly to provide you with immediate online access to the world’s most extensive and up-to-date archive of professional insights into global markets, companies, goods, and patterns. Contact us Quince Market Insights Phone APAC +91 706 672 4343 / US +1 208 405 2835 / UK +44 1444 39 0986 Email info@quincemarketinsights.com
https://w.atwiki.jp/soscomp/pages/194.html
ここのメモ書きは多分SQLite3対応 インストール 使ってみる Pythonと連携 Rubyと連携 C#と連携 メモ [部分編集] インストール ダウンロード 公式サイトから Precompiled Binaries For Windowsの最新版をダウンロード 300kBくらいしかないので心配になりますが、これで全部です。他に何も要らない。 [部分編集] インストール アーカイブを解凍したら、sqlite3.exeを適当なディレクトリに配置。 それからそこにパスを通す。至って簡単ですね。 Linuxの場合はapt-getなどで入れた方がよさげ [部分編集] 使ってみる まずコマンドプロンプトだかターミナルエミュレーターだかを立ち上げてください。 なお、SQLiteはほとんどのSQLコマンドを認識するのでいろんなコマンドを用いることができる。 データベースの作成 sqlite3 [[データベース]]名 1データベース = 1ファイルなのがSQLIteの特徴。 データベース名はそのままファイル名になります。 単純明快。 テーブルの作成 sqlite3 sqlite create table テーブル名(カラム名1, カラム名2, ..., カラム名n); テーブルの一覧を表示 sqlite .tables .tablesはSQLiteの独自コマンドですが、MySQLより単純明快。 テーブルにデータを追加 sqlite insert into テーブル名 values(データ1, データ2, .... データn); テーブルのデータの値を変更 sqlite update テーブル名 set 代入式 (Where 条件); テーブルのデータを表示 sqlite select * from テーブル名; SELECT文の表示形式を変更する sqlite .mode モード名; モード名は、csv, column, html, insert, line, list, tabs, tclのうちのどれか。 コマンドラインで使うときはcolumnが見やすい。 テーブルを丸ごと削除 sqlite drop table テーブル名; [部分編集] Pythonと連携 PythonからSQLiteを利用する [部分編集] Rubyと連携 RubyでSQLiteを使う場合はまずgemを使えるようにしておく。 ActiveScriptRubyを入れておけば他は何もいらないはず。 gem install sqlite3-ruby Windowsの場合は、最新版のver1.2.4が入らないのでver1.2.3を入れます。 gem install sqlite3-ruby --version '= 1.2.3' 参考 使い方はここを参考に。 [部分編集] C#と連携 System.Data.SQLite SQLiteをC#で書きなおした、いわゆる移植版。 しかし世の中にはすごいことをする人もいるもんだなぁ・・・。 使い方は以下のページが詳しい C#からSQLiteを使ってみた [部分編集] メモ WEBRickと組み合わせてローカルでもサーバーで動くWebベースのデータベース操作ツール作ったら面白いかもプログラムはRubyファイルひとつにまとめて、Windowsならダブルクリックしてブラウザでアクセスするだけで使えるようにする 参考サイト http //www.tuyudaku.net/sqlite/ http //www.gesource.jp/programming/ruby/database/sqlite.html 名前 コメント このページへのアクセス数 total - today - yesterday - このページのタグ一覧 データベース SQL SQLite
https://w.atwiki.jp/novo/pages/106.html
名前 SmartQ (智器) 公式サイト http //www.smartdevices.com.cn/ ページ一覧